package com.bkgy.controller.tpdol3data.dao;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.bkgy.commom.model.Temp;
import com.bkgy.controller.tpdol3data.entity.TPdoDataL3Tcm2280;
import com.bkgy.controller.tpdol3data.entity.TpdoL3;
import com.bkgy.controller.tpdol3data.entity.TpdoL3TcmCrew;
import com.bkgy.controller.tpdol3data.entity.TpdoL3TcmYield;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;

@Mapper
public interface TPdoL3Tcm2280Dao extends BaseMapper<TPdoDataL3Tcm2280> {
    public List<TpdoL3TcmYield> findData(String startDay, String endDay);

    public List<TpdoL3TcmCrew> findCrewData(String startDay, String endDay);

    /**
     * 查询酸轧班组达成率
     */
    public List<TpdoL3> findCrewAchiData(String dateType, String crew, String startDay, String endDay);

    public List<TpdoL3> findL3LiyongData(String startDay, String endDay);

    /**
     * 查询连退1630月数据
     */
    public TpdoL3 findL3Data1630(String startDay, String endDay);

    /**
     * 查询连退2150月数据
     */
    public TpdoL3 findL3Data2150(String startDay, String endDay);

    /**
     * 查询连退2150月数据
     */
    public TpdoL3 findL3Data1870(String startDay, String endDay);

    /**
     * 查询酸轧成材率
     */
    public TpdoL3TcmYield findYield2280Data(String startDay, String endDay);

    public TpdoL3TcmYield findYield2150Data(String startDay, String endDay);

    public TpdoL3TcmYield findYield1630Data(String startDay, String endDay);

    public TpdoL3TcmYield findYield1870Data(String startDay, String endDay);

    public List<TpdoL3TcmYield> findYield2280ByDayData(String dateType, String startDay, String endDay);

    /**
     * 高强钢产量
     */
    public List<TpdoL3TcmCrew> findStrongSteel(@Param("ew") Wrapper<TPdoDataL3Tcm2280> wrapper);


    public List<TpdoL3TcmCrew> findEnWidthSteel(@Param("ew") Wrapper<TPdoDataL3Tcm2280> wrapper);

    public List<TpdoL3TcmCrew> findExThickSteel(@Param("ew") Wrapper<TPdoDataL3Tcm2280> wrapper);

    public List<TpdoL3TcmCrew> findWaiSteel(String startDay, String endDay);

    List<TpdoL3TcmYield> findHourData(int rowNum);

    List<Temp> selectCurrentHourOutput(String startTime);

    Temp selectTopOneRecord();

    List<Temp> selectDayOutput(String startTime);

    Temp selectToc(String entId);

    List<Temp> selectLastRoll(int rollNum);

    BigDecimal selectXiada(String today);
}




